package com.jack.database_exp.mapper;
import com.jack.database_exp.bean.Sell;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import java.util.List;

public interface SellMapper {
    @Options(useGeneratedKeys = true,keyProperty = "SNo")
    @Insert("insert into sell (STotal,SDate,WNo) values(#{STotal},#{SDate},#{WNo})")
    public int insertSell(Sell sell);
    @Select("Select * from sell")
    public List<Sell>  querySells();
}
